﻿CREATE TABLE [dbo].[dynamic_menu]
(
	[menu_id] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
    [menu_name] NVARCHAR(50) NOT NULL, 
    [url] NVARCHAR(255) NOT NULL, 
    [parent_id] BIGINT, 
    [visible] BIT NOT NULL DEFAULT 1, 
	[order_position] INT NOT NULL ,
    CONSTRAINT [FK_dynamic_menu_dynamic_menu] FOREIGN KEY (parent_id) REFERENCES dynamic_menu(menu_id)
)
